﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Maticsoft.DBUtility;

namespace RLZY.others
{
    class information
    {
        /// <summary>
        /// 信息查询
        /// </summary>
        public DataSet GetInformation(string name,String nameid)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  * from mess ");
            strSql.Append(" where 1=1 and (姓名 like '%'+@strWhere+'%' or @strWhere='') and (身份证号 like '%'+@strWhere1+'%' or @strWhere1='') ");
            strSql.Append("  order by 姓名 asc ");
            SqlParameter[] param = new SqlParameter[] 
            { 
                
                new SqlParameter("@strWhere",name),
                new SqlParameter("@strWhere1",nameid),
                
            };
            return DbHelperSQL.Query(strSql.ToString(), param);
        }
    }
}
